High Level Architecture of Oracle Insurance Rules Workbench

Oracle Insurance Rules Workbench is a web-based user interface tool designed to support CRUD operations for rules, enable easy migration across environments, and scale applications based on load. It is lightweight, supports seamless integrations, and offers containerization for both cloud and on-premise deployments.

The Rules Workbench eliminates the need for:

  1. The palette config web utility.

  2. Standalone applications for each configurator.

  3. Manual sharing of environment details or database credentials (these are securely stored and accessed internally).

Architecture Overview

The Rules Workbench web application is built with Oracle JET and runs on NodeJS. The application communicates with backend microservices through REST APIs. Two primary microservices support the architecture:

  • The Palette microservice is built with the Helidon framework and connects to the OIPA schema.

  • The Release Management (RM) microservice is built with the Helidon framework and connects to the IVS schema.

    These microservices communicate directly with each other. A REST client is used to enable secure and efficient calls between the services.

    System Components

    The Oracle Insurance Rules Workbench consists of three main services, each with a distinct responsibility.

    Core Services

    • Palette Service: Handles rule or entity-specific business logic, CRUD operations, and configuration management.

    • Release Management Service: Manages migration logic and CRUD operations for version information.

    • Palette Web: The Oracle JET-based user interface, delivering visual workflows and communicating with backend services via AJAX and REST APIs.

    Communication & Integration

    • All interactions between the user interface and backend services are performed via secure REST API and HTTP/HTTPS calls with enforced authentication and authorization.

    • The architecture supports modular, API-driven loading of rules and navigation elements for real-time responsiveness.

    • Containerization: Supports deployment to both cloud and on-premises environments.

    Databases

    • Policy Administration System Database (PAS): Stores policy configuration and core business data.

    • Internal Versioning System Database (IVS): Manages versioning, migration sets, and rule change history.

    • Rules Workbench Schema: Handles user authentication, roles, and access control through privileges and environment details.

      • This schema stores user credentials, roles, environment information, and other related data.

      • It supports multi-environment and multi-user functionality within a single instance, allowing access to multiple environments for each user without requiring separate logins.

      • Facilitates API-driven navigation and controlled loading of rule data, optimizing performance and access security.

    Access & Security

    • Oracle Insurance Rules Workbench operates exclusively over secure HTTP/HTTPS protocols.

    • Database credentials and environment variables are securely stored within the system and are not shared manually.

    • API-driven navigation ensures only necessary data is loaded as needed, enhancing both performance and security.